<%@ page import="java.util.List" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %><%--
  Created by IntelliJ IDEA.
  User: 糍粑呀
  Date: 2018/4/2
  Time: 19:55
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>userList</title>
</head>
<style type="text/css">
    td, th {
        border: 0px;
        padding: 1px;
    }

    table {
        border: 0px;
        border-collapse: collapse;
    }
</style>
<h1>用户管理信息系统</h1>
<body>
<style type="text/css">

    table{border-collapse: collapse;}

      td{border:1px solid #000000;
       padding:10px}
</style>
<!--include 动作-->
<%--<jsp:include page="header.jsp"></jsp:include>>--%>

<table>
    <tr>
        <td>姓名</td>
        <td>编号</td>
        <td>密码</td>
        <td></td>
        <td></td><!--ctrl+w-->

    </tr>

   <%
       class User{
           int id;
           String name;
           String password;
       }

       List<User> userlist=new ArrayList<User>();

      /* User chen=new User();
       chen.id=1;
       chen.name="jdcuwij";
       chen.password="123";

       userlist.add(chen);
       */

       Connection connection=null;
       Statement statement=null;
       ResultSet resultSet=null;

       String sql="select * from t_user";
       Class.forName("com.mysql.jdbc.Driver");

       connection= DriverManager.getConnection(
               "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=Asia/Shanghai\n",
               "root",
               "123456"
               );
       statement=connection.createStatement();
       resultSet=statement.executeQuery(sql);
       while(resultSet.next()){
           int id=resultSet.getInt(1);
           String name=resultSet.getString(2);
           String password=resultSet.getString(3);

           User user=new User();
           user.id=id;
           user.name=name;
           user.password=password;

           userlist.add(user);




       }
       resultSet.close();
       statement.close();
       connection.close();



       for(User user:userlist){
           out.write("<tr><td>" + user.id + "</td><td>" + user.name + "</td><td>" + user.password
                   + "</td><td><a href='userUpdate.jsp?id=" + user.id + "&name="+user.name+"&psd="+user.password+"'>更新</a></td><td><a href='userdelete.jsp?id="
                   + user.id + "'>删除</a></td></tr>\n");

       }
   %>
</table>

<jsp:include page="footer.jsp">
    <jsp:param name="year" value="2018"/>
</jsp:include>





</body>
</html>
